select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Shilin Garden%' or b.enpropertyname like '%Shilin Garden%') order by updateTime Desc, a.dftpic desc
The kitchen is equipped with oven, steaming oven and sterilizing cabinet. The surrounding environment of the district is clean and tidy, with two stairs and thr...
Perfect decoration style,Large livingroom and bedroom,With a balcony,Bright kitchen and livingroom,Comfortable living environment,Close to the metro line,Transp...
Delicated decoration,the property comprises a brigh and sunny living room and well equipped contemporary kitchen, north-south transparent, good ventilation, goo...